SELECT purchase.id, purchase.code AS displayText, 
        '{}' AS otherField
        FROM purchase 
        WHERE purchase.deleted = '0'  AND (code LIKE LOWER('%pu00054%') ) 
        ORDER BY id LIMIT 10 ;